This is my text number1

Station Site_No Latitude Longitude Gauge_Type
Upper San Juan Streamflow Gauges (10)
Ef San Juan R Ab Sand Creek, Nr Pagosa Spgs, Co. 09339900 37.38973 -106.8412 Streamflow
East Fork San Juan River Nr Pagosa Springs, Co 09340000 37.36890 -106.8925 Streamflow
Wf San Juan R Ab Borns Lake,Nr Pagosa Spgs, Co. 09340500 37.48556 -106.9303 Streamflow
W Fk San Juan R At W Fk Campgr Nr Pagosa Spr, Co 09340800 37.45028 -106.9117 Streamflow
Wolf Creek Near Pagosa Springs, Co. 09341200 37.44640 -106.8839 Streamflow
Wolf Cr At Wolf Cr Campgr Nr Pagosa Spr, Co 09341300 37.44195 -106.8870 Streamflow
Windy Pass Cr Nr Pagosa Spr, Co. 09341350 37.43917 -106.8800 Streamflow
West Fork San Juan River Near Pagosa Springs, Co 09341500 37.39247 -106.9069 Streamflow
Turkey Creek Near Pagosa Springs, Co. 09342000 37.36945 -106.9403 Streamflow
San Juan River At Pagosa Springs, Co 09342500 37.26553 -107.0110 Streamflow
Note: Here is an example of the type of dataframe we can pull from USGS and then either use for analysis/graphing/mapping in R, or export into an Excel document. We could also put together summary statistics in a talbe like this for streamflow, snowpack, etc., perhaps to accompany a graph or map.

State Site Start_Date End_Date Lat Long Elevation_ft County HUC Site_ID
AK Frostbite Bottom 2019-February 2100-January 61.75 -149.27 2700 Matanuska-susitna Fishhook Creek-Little Susitna River (190205051202) SNTL:641
AK McGrath 2019-August 2100-January 62.95 -155.61 340 Yukon-koyukuk Town of McGrath-Kuskokwim River (190304050502) SNTL:785
AK East Palmer 2018-July 2100-January 61.60 -149.10 230 Matanuska-susitna Outlet Matanuska River (190204020709) SNTL:953
AK Galena AK 2018-August 2100-January 64.70 -156.71 410 Yukon-koyukuk Louden Slough-Yukon River (190902051104) SNTL:429
AK Flower Mountain 2017-August 2100-January 59.40 -136.28 2510 Haines Porcupine Creek (190103031206) SNTL:1285
AK Heen Latinee 2015-October 2100-January 58.70 -134.86 2065 Juneau Davies Creek (190103010401) SNTL:1270
AK Jack Wade Jct 2015-October 2100-January 64.15 -141.33 3585 Southeast Fairbanks Kal Creek (190705022204) SNTL:1275
AK Lower Kachemak Creek 2015-June 2100-January 59.74 -150.69 1915 Kenai Peninsula Bradley Lake (190203011101) SNTL:1265
AK Alexander Lake 2014-August 2100-January 61.75 -150.89 160 Matanuska-susitna Headwaters Alexander Creek (190205051106) SNTL:1267
AK Fielding Lake 2014-August 2100-January 63.20 -145.63 3000 Valdez-cordova Fielding Lake (190803040302) SNTL:1268
AK Telaquana Lake 2014-July 2100-January 60.98 -153.92 1275 Bethel Upper Telaquana River (190304052303) SNTL:1266
AK Mcneil River SGS 2012-June 2100-January 59.08 -154.28 140 Kenai Peninsula Mikfik Creek-Frontal Kamishak Bay (190206021207) SNTL:1191
AK American Creek 2011-August 2100-January 64.79 -141.23 1050 Southeast Fairbanks American Creek (190705050504) SNTL:1189
AK Exit Glacier 2011-July 2100-January 60.19 -149.62 400 Kenai Peninsula Oulet Resurrection River (190202020508) SNTL:1092
AK Chisana 2007-October 2100-January 62.07 -142.05 3320 Valdez-cordova Red Hill Creek-Chisana River (190803010305) SNTL:1093
AK May Creek 2006-October 2100-January 61.35 -142.71 1610 Valdez-cordova Lower Young Creek (190201031603) SNTL:1096
AK Sugarloaf Mtn 2006-October 2100-January 61.08 -146.30 550 Valdez-cordova Solomon Gulch (190202011101) SNTL:1095
AK Tokositna Valley 2005-October 2100-January 62.63 -150.78 850 Matanuska-susitna Upper Tokositna River (190205020903) SNTL:1089
AK Upper Nome Creek 2005-October 2100-January 65.37 -146.59 2520 Yukon-koyukuk Sumner Creek-Nome Creek (190804020304) SNTL:1090
AK Anchorage Hillside 2004-October 2100-January 61.11 -149.67 2080 Anchorage South Fork Campbell Creek (190204010601) SNTL:1070